Raw Request:
POST /listings/_search?pretty=true&error_trace=true&typed_keys=true
{"from":0,"query":{"bool":{"filter":[{"terms":{"systemid":[406,407]}},{"bool":{"must_not":[{"term":{"flag_publicsearch":{"value":false}}}]}},{"terms":{"type_search":[0,1]}},{"terms":{"type_transactiontype":[0,2]}}],"must":[{"match":{"location_city":{"operator":"and","query":"Norway"}}},{"multi_match":{"fields":["location_*","id_listingid"],"operator":"and","query":"SC","type":"cross_fields"}}]}},"size":25,"sort":[{"date_list":{"order":"desc"}}],"_source":{"includes":["systemid","detailtablename","id_listinguid","id_listingid","id_primarylistingoffice","id_primarylistingofficename","id_primarylistingagent","status_display","location_streetaddress","location_city","location_state","location_postalcode","bedrooms","bathrooms_total","price_list","price_closed","primaryimage","squarefootage","geo_coordinates","type_search","type_transactiontype","type_propertytype","type_status","obj_openhouses","date_list","remarks","flag_*"]}}
Raw Response:
{
"took" : 11,
"timed_out" : false,
"_shards" : {
"total" : 3,
"successful" : 3,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 5,
"relation" : "eq"
},
"max_score" : null,
"hits" : [
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-570492",
"_score" : null,
"_source" : {
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-570492",
"id_primarylistingofficename" : "Keller Williams Realty",
"type_search" : 0,
"type_propertytype" : 40,
"bathrooms_total" : 0,
"id_primarylistingagent" : "16847",
"date_list" : "2023-09-16T00:00:00",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "Winchester Avenue",
"location_postalcode" : "29113",
"bedrooms" : 0,
"flag_internetadvertise" : true,
"price_list" : 5000.0,
"id_primarylistingoffice" : "669",
"location_city" : "NORWAY",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -81.1271958134918,
"lat" : 33.4526744456835
},
"id_listingid" : "570492",
"type_transactiontype" : 0
},
"sort" : [
1694822400000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-AMLSSC-206898",
"_score" : null,
"_source" : {
"status_display" : "Pending",
"systemid" : 407,
"id_listinguid" : "3yd-AMLSSC-206898",
"id_primarylistingofficename" : "David Porter Realty, LLC",
"type_search" : 1,
"type_propertytype" : 19,
"bathrooms_total" : 0,
"id_primarylistingagent" : "327_1",
"date_list" : "2023-06-20T00:00:00",
"type_status" : 1,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "0 Carmichael Circle",
"location_postalcode" : "29113",
"bedrooms" : 0,
"flag_internetadvertise" : true,
"price_list" : 133500.0,
"id_primarylistingoffice" : "327",
"location_city" : "Norway",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -81.077533,
"lat" : 33.429907
},
"id_listingid" : "206898",
"type_transactiontype" : 0
},
"sort" : [
1687219200000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-551173",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-551173",
"type_search" : 0,
"bathrooms_total" : 0,
"id_primarylistingagent" : "13761",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "8291 Savannah Highway",
"flag_internetadvertise" : true,
"price_list" : 250000.0,
"location_city" : "NORWAY",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -81.124856,
"lat" : 33.452388
},
"id_primarylistingofficename" : "Jeff Cook Real Estate LLC",
"type_propertytype" : 19,
"date_list" : "2022-10-13T00:00:00",
"location_postalcode" : "29113",
"bedrooms" : 0,
"id_primarylistingoffice" : "1220",
"squarefootage" : 2800,
"id_listingid" : "551173",
"type_transactiontype" : 0
},
"sort" : [
1665619200000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-AMLSSC-203102",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-AMLSSC-203102",
"type_search" : 0,
"bathrooms_total" : 3,
"id_primarylistingagent" : "109_2",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "7948 Savannah Highway",
"flag_internetadvertise" : true,
"price_list" : 789900.0,
"location_city" : "Norway",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -81.127286,
"lat" : 33.468381
},
"id_primarylistingofficename" : "Keller Williams Palmetto",
"type_propertytype" : 0,
"date_list" : "2022-09-06T00:00:00",
"location_postalcode" : "29113",
"bedrooms" : 3,
"id_primarylistingoffice" : "109",
"squarefootage" : 3686,
"id_listingid" : "203102",
"type_transactiontype" : 0
},
"sort" : [
1662422400000
]
},
{
"_index" : "listings_v1",
"_type" : "_doc",
"_id" : "407-3yd-CMLSSC-548876",
"_score" : null,
"_source" : {
"status_display" : "Active",
"systemid" : 407,
"id_listinguid" : "3yd-CMLSSC-548876",
"type_search" : 0,
"bathrooms_total" : 3,
"id_primarylistingagent" : "12885",
"type_status" : 0,
"flag_showstreetaddress" : true,
"flag_publicsearch" : true,
"location_state" : "SC",
"location_streetaddress" : "7948 Savannah Highway",
"flag_internetadvertise" : true,
"price_list" : 789900.0,
"location_city" : "Norway",
"detailtablename" : "feed_8/Property",
"geo_coordinates" : {
"lon" : -81.127286,
"lat" : 33.468381
},
"id_primarylistingofficename" : "Keller Williams Palmetto",
"type_propertytype" : 19,
"date_list" : "2022-09-02T00:00:00",
"location_postalcode" : "29113",
"bedrooms" : 3,
"id_primarylistingoffice" : "1274",
"squarefootage" : 3686,
"id_listingid" : "548876",
"type_transactiontype" : 0
},
"sort" : [
1662076800000
]
}
]
}
}